Functoid - IndexOf

IndexOf Functoid

Description: The IndexOf Functoid returns the numeric value of the Index at which ParamB is found in ParamA for the first time. Inputs with their allowed values:

• ParamA
  • May be a single character, a string or a number
  • Literal text entered manually
  • Output of another Functoid
  • Value of a Table
• ParamB
  • May be a single character, a string or a number
  • Literal text entered manually
  • Output of another Functoid
  • Value of a Table

Picture of the IndexOf Functoid

Remark: When ParamB isn't found, the output will be -1. The IndexOf Functoid is often used in combination with the Substring Functoid. Example:

• ParamA
  • Literal value : 123ABC12345BC
• ParamB
  • Literal value : BC
• Output
  • 4

See Figure 1.

Figure1